﻿--header AssignmentStat
if (exists(
select * from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA = 'iComply'
and TABLE_NAME='AssignmentStat'))
BEGIN
Drop table iComply.AssignmentStat
END

GO

 create table iComply.AssignmentStat(
Id int not null  IDENTITY(1,1),
AssignmentId uniqueidentifier NOT NULL,
[Date] DateTime2 not null,
StatType nvarchar(500) not null,
Value nvarchar(max) null,
CONSTRAINT PK_AssignmentStat PRIMARY KEY (ID)
)
